package com.nCoV.EpidemicSurveillance.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author 罗穆健
 * @date 2020年5月1日
 */
@Mapper
public interface TjMapper {

	@Insert("INSERT INTO tjCity(id,province,city,area,qznum,gfxnum,zynum,tjDate) "
			+ "VALUES(#{id},#{province},#{city},#{area},#{qznum},#{gfxnum},#{zynum},#{tjDate})")
	public void insertCityTj(String id, String province, 
			String city, String area, int qznum, int gfxnum, int zynum,String tjDate);
	
	@Select("SELECT province,city,area,	qznum,gfxnum,zynum from tjCity as tj where tj.tjDate = #{nowDay}")
	public List<Map<String, Object>> getTodayData(String nowDay);
}
